package com.yiyi.credit.manage.sso.mapper;


import com.yiyi.credit.manage.sso.common.constants.PaginationConstants;
import com.yiyi.credit.manage.sso.common.page.PageUtils;

import java.util.Map;


public class SysInfoSqlProvider {

    //查询表
    private String fromInfo = " from sys_info ";


    public String queryForPage(Map<String, Object> paramMap) {
        //查询字段
        String selectFiled = " id,name,create_time createTime,update_time updateTime ";

        return PageUtils.getPageCommonSql(selectFiled, fromInfo, "", "id")
                + PaginationConstants.LIMIT_SQL;
    }


    public String queryCount(Map<String, Object> paramMap) {
        //查询条数
        String countFiled = " count(id) count ";
        return PageUtils.getPageCountSql(countFiled, fromInfo, "");
    }

}
